Sheet: (0, 0) EV Design Version (0, 1) 1.1 (0, 4) DIALOGS (0, 13) MENUS (1, 0) Motor Data Available (1, 1) commands (1, 2) comments (1, 4) type (1, 5) x (1, 6) y (1, 7) wide (1, 8) high (1, 9) text (1, 10) init/result (1, 11) names (1, 13) Names (1, 14) Command (1, 15) Macro (1, 16) Key (1, 17) Status Bar Text (1, 18) Help (1, 19) (2, 4) (2, 5) (2, 6) (2, 7) (2, 8) (2, 9) (2, 10) (2, 11) (2, 19) (3, 0) Electric Motor Model (3, 1) Data Filename (3, 4) EVBuilder (3, 5) (3, 6) (3, 7) (3, 8) (3, 9) (3, 10) (3, 11) (3, 13) Menu_EV_Design (3, 14) EV Design (3, 19) (4, 0) Advanced DC 203-06-4001 (4, 1) ADC20306.xls (4, 4) (4, 5) (4, 6) (4, 7) (4, 8) (4, 9) EV Builder (4, 10) 2 (4, 11) (4, 13) (4, 14) Setup EV (4, 15) [EVWorkBk.xls]EVMacros.xlm!buildEV (4, 16) b (4, 17) Enter design parameters for EV (4, 18) (4, 19) (5, 0) Advanced DC A89-4003 (5, 1) ADC_A89.xls (5, 4) 1 (5, 5) 333 (5, 6) 300 (5, 7) 64 (5, 8) (5, 9) OK (5, 10) (5, 11) (5, 13) (5, 14) - (5, 15) (5, 16) (5, 17) (5, 18) (5, 19) (6, 0) Advanced DC FB1-4001 (6, 1) ADC_FB1.xls (6, 4) 2 (6, 5) 412 (6, 6) 300 (6, 7) 64 (6, 8) (6, 9) Cancel (6, 10) (6, 11) (6, 13) (6, 14) Print All (6, 15) [EVWorkBk.xls]EVMacros.xlm!PrintAll (6, 16) p (6, 17) Print all pages of spreadsheet (6, 18) (7, 0) Advanced DC K91-4003 (7, 1) ADC_K91.xls (7, 4) 5 (7, 5) 44 (7, 6) 17 (7, 7) (7, 8) (7, 9) Car Model (7, 10) (7, 11) (7, 13) (7, 14) (7, 15) (7, 16) (7, 17) (7, 18) (8, 0) Advanced DC L91-4003 (8, 1) ADC_L91.xls (8, 4) 5 (8, 5) 28 (8, 6) 89 (8, 7) (8, 8) (8, 9) Model Motor (8, 10) (8, 11) (8, 13) (8, 14) (8, 15) (8, 16) (8, 17) (8, 18) (9, 0) (9, 4) 5 (9, 5) 10 (9, 6) 124 (9, 7) (9, 8) (9, 9) Drive Efficiency (9, 10) (9, 11) (10, 0) (10, 1) auto_open (10, 2) (10, 4) 6 (10, 5) 124 (10, 6) 13 (10, 7) 240 (10, 8) (10, 9) (10, 10) Honda Civic 1500S, 1984 (10, 11) Dlg_Car (11, 0) (11, 1) [EVWorkbk.xls]EVMacros.xl (11, 2) name of this document (11, 4) 21 (11, 5) 124 (11, 6) 85 (11, 7) 240 (11, 8) 1 (11, 9) [EVWorkBk.xls]MotorLst.xls!Motor_Model_List (11, 10) 3 (11, 11) Dlg_Motor (12, 0) (12, 1) 9 (12, 2) add EV Design menu (12, 4) 7 (12, 5) 294 (12, 6) 121 (12, 7) 34 (12, 8) (12, 9) (12, 10) 65 (12, 11) Dlg_Speed (13, 0) (13, 1) TRUE (13, 2) get home directory (13, 4) 5 (13, 5) 332 (13, 6) 124 (13, 7) (13, 8) (13, 9) mph (13, 10) (13, 11) (14, 0) (14, 1) TRUE (14, 2) motor data dir (14, 4) 14 (14, 5) 178 (14, 6) 171 (14, 7) 100 (14, 8) 124 (14, 9) Batteries (14, 10) (14, 11) (15, 0) (15, 1) #N/A! (15, 2) create list of motors (15, 4) 11 (15, 5) (15, 6) (15, 7) (15, 8) (15, 9) (15, 10) 12 (15, 11) Dlg_Bat_V (16, 0) (16, 1) TRUE (16, 2) (16, 4) 12 (16, 5) (16, 6) (16, 7) (16, 8) (16, 9) 6 Volt (16, 10) (16, 11) (17, 4) 12 (17, 5) (17, 6) (17, 7) (17, 8) (17, 9) 12 Volt (17, 10) (17, 11) (18, 0) auto_close (18, 1) auto_close (18, 2) (18, 4) 7 (18, 5) 186 (18, 6) 231 (18, 7) 28 (18, 8) (18, 9) (18, 10) 10 (18, 11) Dlg_Num_Bat (18, 12) FALSE (19, 0) (19, 1) TRUE (19, 2) (19, 4) 7 (19, 5) 186 (19, 6) 263 (19, 7) 28 (19, 8) (19, 9) (19, 10) 86 (19, 11) Dlg_Bat_Wt (19, 12) NEX (20, 0) (20, 1) TRUE (20, 2) (20, 4) 5 (20, 5) 218 (20, 6) 235 (20, 7) (20, 8) (20, 9) Cells (20, 10) (20, 11) (20, 12) NEXT (21, 0) (21, 4) 5 (21, 5) 218 (21, 6) 267 (21, 7) (21, 8) (21, 9) lbs/cell (21, 10) (21, 11) (22, 1) Update TrqAvail.xls for new motor or voltage (22, 4) 5 (22, 5) 196 (22, 6) 124 (22, 7) (22, 8) (22, 9) Design Speed (22, 10) (22, 11) (23, 0) newMotor (23, 1) newMotor (23, 2) (23, 4) 5 (23, 5) 12 (23, 6) 53 (23, 7) (23, 8) (23, 9) Original Weight (23, 10) (23, 11) (24, 0) (24, 1) TRUE (24, 2) (24, 4) 5 (24, 5) 220 (24, 6) 53 (24, 7) (24, 8) (24, 9) Removed (24, 10) (24, 11) (25, 0) (25, 1) TRUE (25, 2) (25, 4) 7 (25, 5) 124 (25, 6) 49 (25, 7) 48 (25, 8) (25, 9) (25, 10) 1907 (25, 11) Dlg_Car_Wt (26, 0) (26, 1) TRUE (26, 2) manual calculation (26, 4) 7 (26, 5) 288 (26, 6) 49 (26, 7) 48 (26, 8) (26, 9) (26, 10) 450 (26, 11) Dlg_Wt_Gone (27, 0) (27, 1) TRUE (27, 2) save current dir (27, 4) 8 (27, 5) 124 (27, 6) 121 (27, 7) 48 (27, 8) (27, 9) (27, 10) 0.91 (27, 11) Dlg_Efficiency (28, 0) newFile (28, 1) ADC_FB1.XL (28, 2) match motor name (28, 4) 5 (28, 5) 176 (28, 6) 53 (28, 7) (28, 8) (28, 9) lbs (28, 10) (28, 11) (29, 0) voltsRef (29, 1) ADC_FB1.XLS!Voltag (29, 2) range containing volts (29, 4) 5 (29, 5) 340 (29, 6) 53 (29, 7) (29, 8) (29, 9) lbs (29, 10) (29, 11) (30, 0) RPMref (30, 1) ADC_FB1.XLS!RP (30, 2) range containing RPMs (30, 4) 14 (30, 5) 24 (30, 6) 153 (30, 7) 108 (30, 8) 182 (30, 9) Gear Ratios (30, 10) (30, 11) (31, 0) (31, 1) TRUE (31, 2) get design pack volts (31, 4) 5 (31, 5) 32 (31, 6) 174 (31, 7) (31, 8) 25 (31, 9) 1st (31, 10) (31, 11) (32, 0) (32, 1) C:\DOUG\EVDESIGN\MOTOR (32, 2) set default directory (32, 4) 5 (32, 5) 31 (32, 6) 201 (32, 7) (32, 8) 25 (32, 9) 2nd (32, 10) (32, 11) (33, 0) (33, 1) TRUE (33, 2) open motor data file (33, 4) 5 (33, 5) 32 (33, 6) 228 (33, 7) (33, 8) 25 (33, 9) 3rd (33, 10) (33, 11) (34, 0) (34, 1) FALSE (34, 2) update motor name (34, 4) 5 (34, 5) 32 (34, 6) 255 (34, 7) (34, 8) 25 (34, 9) 4th (34, 10) (34, 11) (35, 0) (35, 1) TRUE (35, 2) update motor weight (35, 4) 5 (35, 5) 32 (35, 6) 281 (35, 7) (35, 8) 25 (35, 9) 5th (35, 10) (35, 11) (36, 0) (36, 1) TRUE (36, 2) update data voltage (36, 4) 5 (36, 5) 32 (36, 6) 309 (36, 7) (36, 8) 25 (36, 9) Diff (36, 10) (36, 11) (37, 0) (37, 1) TRUE (37, 2) torque values (37, 4) 8 (37, 5) 62 (37, 6) 171 (37, 7) 54 (37, 8) (37, 9) (37, 10) 2.916 (37, 11) Dlg_First (38, 0) (38, 1) TRUE (38, 2) current at torque (38, 4) 8 (38, 5) 62 (38, 6) 198 (38, 7) 54 (38, 8) (38, 9) (38, 10) 1.764 (38, 11) Dlg_Second (39, 0) (39, 1) TRUE (39, 2) rpm at torque (39, 4) 8 (39, 5) 62 (39, 6) 225 (39, 7) 54 (39, 8) (39, 9) (39, 10) 1.181 (39, 11) Dlg_Third (40, 0) (40, 1) TRUE (40, 2) delete border format (40, 4) 8 (40, 5) 62 (40, 6) 252 (40, 7) 54 (40, 8) (40, 9) (40, 10) 0.846 (40, 11) Dlg_Fourth (41, 0) (41, 1) TRUE (41, 2) (41, 4) 8 (41, 5) 62 (41, 6) 279 (41, 7) 54 (41, 8) (41, 9) (41, 10) 0.714 (41, 11) Dlg_Fifth (42, 0) (42, 1) TRUE (42, 2) (42, 4) 8 (42, 5) 62 (42, 6) 306 (42, 7) 54 (42, 8) (42, 9) (42, 10) 4.066 (42, 11) Dlg_Diff (43, 0) (43, 1) TRUE (43, 2) (43, 4) 14 (43, 5) 374 (43, 6) 6 (43, 7) 108 (43, 8) 179 (43, 9) Drag (43, 10) (43, 11) (44, 0) (44, 1) TRUE (44, 2) (44, 4) 8 (44, 5) 418 (44, 6) 25 (44, 7) 54 (44, 8) (44, 9) (44, 10) 0.3 (44, 11) Dlg_Cd (45, 0) (45, 1) TRUE (45, 2) (45, 4) 14 (45, 5) 320 (45, 6) 191 (45, 7) 164 (45, 8) 84 (45, 9) Tires (45, 10) (45, 11) (46, 0) (46, 1) TRUE (46, 2) reselect motor file (46, 4) 5 (46, 5) 327 (46, 6) 215 (46, 7) (46, 8) (46, 9) Size (46, 10) (46, 11) (47, 0) (47, 1) TRUE (47, 2) close it (47, 4) 8 (47, 5) 418 (47, 6) 57 (47, 7) 54 (47, 8) (47, 9) (47, 10) 0.012 (47, 11) Dlg_Cr (48, 0) (48, 1) C:\DOUG\EVDESIG (48, 2) reset default directory (48, 4) 8 (48, 5) 418 (48, 6) 89 (48, 7) 54 (48, 8) (48, 9) (48, 10) 1.2 (48, 11) Dlg_Crw (49, 0) (49, 1) TRUE (49, 2) (49, 4) 8 (49, 5) 418 (49, 6) 121 (49, 7) 54 (49, 8) (49, 9) (49, 10) 16 (49, 11) Dlg_Area (50, 0) (50, 1) TRUE (50, 2) automatic calculation (50, 4) 8 (50, 5) 418 (50, 6) 153 (50, 7) 54 (50, 8) (50, 9) (50, 10) 9 (50, 11) Dlg_Wind (51, 0) (51, 1) TRUE (51, 2) (51, 4) 5 (51, 5) 394 (51, 6) 29 (51, 7) (51, 8) (51, 9) Cd (51, 10) (51, 11) (52, 0) (52, 1) TRUE (52, 2) (52, 4) 5 (52, 5) 394 (52, 6) 61 (52, 7) (52, 8) (52, 9) Cr (52, 10) (52, 11) (53, 4) 5 (53, 5) 382 (53, 6) 93 (53, 7) (53, 8) (53, 9) Crw (53, 10) (53, 11) (54, 1) Create list of motors and data files available (54, 4) 5 (54, 5) 378 (54, 6) 125 (54, 7) (54, 8) (54, 9) Area (54, 10) (54, 11) (55, 0) motorList (55, 1) motorList (55, 2) (55, 4) 5 (55, 5) 378 (55, 6) 156 (55, 7) (55, 8) (55, 9) Wind (55, 10) (55, 11) (56, 0) (56, 1) TRUE (56, 2) (56, 4) 5 (56, 5) 443 (56, 6) 247 (56, 7) (56, 8) (56, 9) in. (56, 10) (56, 11) (57, 0) (57, 1) TRUE (57, 2) (57, 4) 6 (57, 5) 360 (57, 6) 211 (57, 7) 114 (57, 8) (57, 9) (57, 10) 175/70R13 (57, 11) Dlg_Tire_Size (58, 0) (58, 1) TRUE (58, 2) save current dir (58, 4) 5 (58, 5) 327 (58, 6) 247 (58, 7) (58, 8) (58, 9) Diameter (58, 10) (58, 11) (59, 0) (59, 1) TRUE (59, 2) (59, 4) 8 (59, 5) 396 (59, 6) 243 (59, 7) 44 (59, 8) (59, 9) (59, 10) 24 (59, 11) Dlg_Tire_Dia (60, 0) (60, 1) TRUE (60, 2) clear old model data (61, 0) (61, 1) TRUE (61, 2) (61, 4) ud01.Results (62, 0) (62, 1) TRUE (62, 2) clear old file data (62, 4) Excelhlp.hlp!523 (62, 5) (62, 6) (62, 7) (62, 8) (62, 9) Command Results (62, 10) 2 (62, 11) (63, 0) (63, 1) TRUE (63, 2) (63, 4) 5 (63, 5) 8 (63, 6) 10 (63, 7) 300 (63, 8) (63, 9) Result of=FORMULA(Dlg_Car,EVDesign.xls!Car_Model) (63, 10) (63, 11) (64, 0) (64, 1) DCW Quadra:DCW:Personal:EV:EVDesign:Motor (64, 2) set default directory (64, 4) 6 (64, 5) 8 (64, 6) 33 (64, 7) 262 (64, 8) (64, 9) (64, 10) TRUE (64, 11) ud01s.command (65, 0) (65, 1) TRUE (65, 2) file names to array (65, 4) 2 (65, 5) 280 (65, 6) 32 (65, 7) (65, 8) (65, 9) &Close (65, 10) (65, 11) (66, 0) (66, 1) TRUE (66, 2) did we get any files? (67, 0) (67, 1) FALSE (67, 2) (67, 4) ud02.GetCommand (68, 0) (68, 1) TRUE (68, 2) (68, 4) Excelhlp.hlp!523 (68, 5) (68, 6) (68, 7) (68, 8) (68, 9) Command Window (68, 10) 2 (68, 11) (69, 0) (69, 1) TRUE (69, 2) (69, 4) 5 (69, 5) 8 (69, 6) 10 (69, 7) 151 (69, 8) (69, 9) &Execute Command: (69, 10) (69, 11) (70, 0) motorFile (70, 1) ADC_L91.xl (70, 2) data file name (70, 4) 9 (70, 5) 8 (70, 6) 33 (70, 7) 262 (70, 8) (70, 9) (70, 10) (70, 11) ud02s.command (71, 0) (71, 1) TRUE (71, 2) open data file (71, 4) 1 (71, 5) 280 (71, 6) 8 (71, 7) (71, 8) (71, 9) &Run (71, 10) (71, 11) (72, 0) modelName (72, 1) ADC_L91.xls!model_moto (72, 2) (72, 4) 2 (72, 5) 280 (72, 6) 35 (72, 7) (72, 8) (72, 9) &Cancel (72, 10) (72, 11) (73, 0) (73, 1) TRUE (73, 2) (73, 10) TRUE (74, 0) (74, 1) TRUE (74, 2) (75, 0) (75, 1) TRUE (75, 2) (75, 4) International Table, no localization needed (76, 0) (76, 1) TRUE (76, 2) (76, 4) (76, 5) FALSE (76, 6) FALSE (76, 7) FALSE (76, 8) FALSE (76, 9) FALSE (76, 10) FALSE (76, 11) FALSE (77, 0) (77, 1) TRUE (77, 2) (77, 4) LOCAL TEXT (77, 5) I (77, 6) FO (77, 7) FOR.CEL (77, 8) WHIL (77, 9) ELS (77, 10) ELSE.I (77, 11) END.I (78, 0) (78, 1) TRUE (78, 2) (78, 4) INTL TEXT (78, 5) IF (78, 6) FOR (78, 7) FOR.CELL (78, 8) WHILE (78, 9) ELSE (78, 10) ELSE.IF (78, 11) END.IF (79, 0) (79, 1) TRUE (79, 2) (80, 0) (80, 1) TRUE (80, 2) (80, 4) Localization Table, localization needed (81, 0) (81, 1) TRUE (81, 2) (81, 4) Result of (82, 0) (82, 1) TRUE (82, 2) (82, 4) Formula not indented in (83, 0) (83, 1) DCW Quadra:DCW:Personal:EV:EVDesig (83, 2) reset default directory (83, 4) Formula too long, or invalid formula. (84, 0) (84, 1) TRUE (84, 2) (85, 0) (85, 1) TRUE (85, 2) (86, 0) (86, 1) TRUE (86, 2) (87, 0) (87, 1) (87, 2) (87, 4) (87, 5) (87, 6) (87, 7) (87, 8) (87, 9) (87, 10) (87, 11) (87, 13) (87, 14) (87, 15) (87, 16) (87, 17) (87, 18) (87, 19) (88, 1) Process dialog for changing design parameters (89, 0) buildEV (89, 1) buildEV (89, 2) (90, 0) (90, 1) TRUE (90, 2) so refs are relative to us (91, 0) (91, 1) TRUE (91, 2) (92, 0) (92, 1) TRUE (92, 2) (93, 0) (93, 1) TRUE (93, 2) (94, 0) (94, 1) TRUE (94, 2) (95, 0) (95, 1) TRUE (95, 2) (96, 0) (96, 1) TRUE (96, 2) (97, 0) (97, 1) TRUE (97, 2) (98, 0) (98, 1) TRUE (98, 2) (98, 4) (98, 5) (98, 6) (98, 7) (98, 8) (98, 9) (98, 10) (98, 11) (98, 13) (98, 14) (98, 15) (98, 16) (98, 17) (98, 18) (98, 19) (99, 0) (99, 1) TRUE (99, 2) (100, 0) (100, 1) TRUE (100, 2) (101, 0) (101, 1) TRUE (101, 2) (102, 0) (102, 1) TRUE (102, 2) (103, 0) (103, 1) TRUE (103, 2) (104, 0) (104, 1) TRUE (104, 2) (104, 4) (104, 5) (104, 6) (104, 7) (104, 8) (104, 9) (104, 10) (104, 11) (104, 13) (104, 14) (104, 15) (104, 16) (104, 17) (104, 18) (104, 19) (105, 0) (105, 1) TRUE (105, 2) (105, 4) (105, 5) (105, 6) (105, 7) (105, 8) (105, 9) (105, 10) (105, 11) (105, 13) (105, 14) (105, 15) (105, 16) (105, 17) (105, 18) (105, 19) (106, 0) (106, 1) TRUE (106, 2) (107, 0) (107, 1) TRUE (107, 2) (107, 4) (107, 5) (107, 6) (107, 7) (107, 8) (107, 9) (107, 10) (107, 11) (107, 13) (107, 14) (107, 15) (107, 16) (107, 17) (107, 18) (107, 19) (108, 0) (108, 1) TRUE (108, 2) (108, 4) (108, 5) (108, 6) (108, 7) (108, 8) (108, 9) (108, 10) (108, 11) (108, 13) (108, 14) (108, 15) (108, 16) (108, 17) (108, 18) (108, 19) (109, 0) (109, 1) TRUE (109, 2) (109, 4) (109, 5) (109, 6) (109, 7) (109, 8) (109, 9) (109, 10) (109, 11) (109, 13) (109, 14) (109, 15) (109, 16) (109, 17) (109, 18) (109, 19) (110, 0) (110, 1) TRUE (110, 2) (111, 0) (111, 1) TRUE (111, 2) (112, 0) (112, 1) TRUE (112, 2) (113, 0) (113, 1) 0 (113, 2) put up builder dialog (114, 0) (114, 1) TRUE (114, 2) wait to calculate (115, 0) (115, 1) TRUE (115, 2) update cells from dialog (116, 0) (116, 1) TRUE (116, 2) (117, 0) (117, 1) TRUE (117, 2) (118, 0) (118, 1) TRUE (118, 2) (119, 0) (119, 1) TRUE (119, 2) (120, 0) (120, 1) TRUE (120, 2) (121, 0) (121, 1) TRUE (121, 2) (122, 0) (122, 1) TRUE (122, 2) (123, 0) (123, 1) TRUE (123, 2) (124, 0) (124, 1) TRUE (124, 2) (125, 0) (125, 1) TRUE (125, 2) (126, 0) (126, 1) TRUE (126, 2) (127, 0) (127, 1) TRUE (127, 2) (128, 0) (128, 1) TRUE (128, 2) (129, 0) (129, 1) TRUE (129, 2) (130, 0) (130, 1) TRUE (130, 2) (131, 0) (131, 1) TRUE (131, 2) (132, 0) (132, 1) TRUE (132, 2) (133, 0) (133, 1) TRUE (133, 2) (134, 0) (134, 1) TRUE (134, 2) (135, 0) (135, 1) TRUE (135, 2) set V from radio buttons (136, 0) (136, 1) TRUE (136, 2) check for change (137, 0) (137, 1) TRUE (137, 2) update battery voltage (138, 0) (138, 1) TRUE (138, 2) (139, 0) continue1 (139, 1) TRUE (139, 2) (140, 0) (140, 1) TRUE (140, 2) check for change (141, 0) (141, 1) TRUE (141, 2) (142, 0) continue2 (142, 1) TRUE (142, 2) get motor name (143, 0) (143, 1) 0 (143, 2) (144, 0) (144, 1) TRUE (144, 2) automatic calculation (145, 0) (145, 1) 0 (145, 2) (146, 0) EV_Bld_Return (146, 1) TRUE (146, 2) (147, 0) (147, 1) (147, 2) (148, 1) Sort windows into my standard order (149, 0) OrderWindows (149, 1) OrderWindows (149, 2) (150, 0) (150, 1) put all windows in a convenient order (150, 2) (151, 0) (151, 1) TRUE (151, 2) no screen updates (152, 0) (152, 1) TRUE (152, 2) (153, 0) (153, 1) TRUE (153, 2) (154, 0) (154, 1) TRUE (154, 2) (155, 0) (155, 1) TRUE (155, 2) (156, 0) (156, 1) TRUE (156, 2) (157, 0) (157, 1) TRUE (157, 2) (158, 0) (158, 1) TRUE (158, 2) (159, 0) (159, 1) TRUE (159, 2) (161, 1) Print all EVDesign pages at once (162, 0) PrintAll (162, 1) PrintAll (162, 2) (163, 0) (163, 1) print all spreadsheet pages (163, 2) (164, 0) (164, 1) TRUE (164, 2) (165, 0) (165, 1) TRUE (165, 2) (166, 0) (166, 1) TRUE (166, 2) (167, 0) (167, 1) TRUE (167, 2) (168, 0) (168, 1) TRUE (168, 2) (169, 0) (169, 1) TRUE (169, 2) (170, 0) (170, 1) TRUE (170, 2) (171, 0) (171, 1) TRUE (171, 2) (172, 0) (172, 1) TRUE (172, 2) (173, 0) (173, 1) FALSE (173, 2) (174, 0) (174, 1) TRUE (174, 2) (175, 0) (175, 1) TRUE (175, 2) (176, 0) (176, 1) TRUE (176, 2) (177, 0) (177, 1) TRUE (177, 2) (180, 0) CommandWindow (180, 1) CommandWindow (180, 2) (181, 0) (181, 1) TRUE (181, 2) so refs are relative to us (182, 0) command.result (182, 1) 3 (182, 2) get the formula to evaluate (183, 0) (183, 1) FALSE (183, 2) (184, 0) (184, 1) TRUE (184, 2) (185, 0) (185, 1) TRUE (185, 2) enter as formula (186, 0) (186, 1) TRUE (186, 2) run it (187, 0) #REF! (187, 1) TRUE (187, 2) Put function in error dialog (188, 0) (188, 1) TRUE (188, 2) Update prompt for error (189, 0) (189, 1) 1 (189, 2) show user result, allow COPY (190, 0) (190, 1) TRUE (190, 2) clear (191, 0) (191, 1) TRUE (191, 2) (192, 1) (193, 0) fnIndent (193, 1) Indent (193, 2) (194, 0) (194, 1) (194, 2) (195, 0) (195, 1) TRUE (195, 2) Set block text to US if indenting INTL macro, else to local text (196, 0) (196, 1) #VALUE! (196, 2) (197, 0) vISelection (197, 1) TRUE (197, 2) (198, 0) (198, 1) TRUE (198, 2) (199, 0) (199, 1) TRUE (199, 2) Initialize current indent (200, 0) vIIndent (200, 1) 4 (200, 2) Number of spaces to indent (201, 0) vIIndentTotal (201, 1) 0 (201, 2) (202, 0) (202, 1) TRUE (202, 2) (203, 0) (203, 1) TRUE (203, 2) (204, 0) (204, 1) TRUE (204, 2) (205, 0) vICleanFormula (205, 1) = (205, 2) (206, 0) vILeftChar (206, 1) (206, 2) Handle implicit name case (207, 0) vICurrentIndent (207, 1) TRUE (207, 2) Strip left char (208, 0) 0 (208, 1) TRUE (208, 2) Strip leading blanks (209, 0) (209, 1) 1 (209, 2) Check for indent type (210, 0) vITestIf (210, 1) TRUE (210, 2) Block if? (211, 0) FALSE (211, 1) FALSE (211, 2) (212, 0) (212, 1) TRUE (212, 2) (213, 0) (213, 1) TRUE (213, 2) Enter, no shift (214, 0) (214, 1) TRUE (214, 2) Insert indent spaces (215, 0) (215, 1) TRUE (215, 2) Enter, then shift right? (216, 0) (216, 1) TRUE (216, 2) Insert indent spaces (217, 0) (217, 1) TRUE (217, 2) Increment Indent (218, 0) (218, 1) TRUE (218, 2) Shift left, enter, then right? (219, 0) (219, 1) TRUE (219, 2) Decrement Indent (220, 0) (220, 1) TRUE (220, 2) Insert indent spaces (221, 0) (221, 1) TRUE (221, 2) Increment Indent (222, 0) (222, 1) TRUE (222, 2) Shift left? (223, 0) (223, 1) TRUE (223, 2) Decrement Indent (224, 0) (224, 1) TRUE (224, 2) Insert indent spaces (225, 0) (225, 1) TRUE (225, 2) (226, 0) (226, 1) TRUE (226, 2) FALSE (227, 0) (227, 1) TRUE (227, 2) (228, 0) (228, 1) #VALUE! (228, 2) Enter normally or Array Enter (229, 0) (229, 1) TRUE (229, 2) (230, 0) (230, 1) TRUE (230, 2) (231, 0) (231, 1) TRUE (231, 2) (232, 0) (232, 1) TRUE (232, 2) (233, 0) (233, 1) TRUE (233, 2) (234, 0) (234, 1) TRUE (234, 2) (236, 0) fnUnIndent (236, 1) UnIndent (236, 2) (237, 0) (237, 1) (237, 2) (238, 0) (238, 1) 3 (238, 2) (239, 0) vUSelection (239, 1) TRUE (239, 2) (240, 0) (240, 1) TRUE (240, 2) (241, 0) vUIndentTotal (241, 1) TRUE (241, 2) (242, 0) (242, 1) TRUE (242, 2) (243, 0) (243, 1) TRUE (243, 2) (244, 0) (244, 1) TRUE (244, 2) (245, 0) vUCleanFormula (245, 1) =IF(ISERROR(R[-1]C) (245, 2) (246, 0) vULeftChar (246, 1) (246, 2) Handle implicit name case (247, 0) vUCurrentIndent (247, 1) TRUE (247, 2) Strip left char (248, 0) 0 (248, 1) TRUE (248, 2) Strip leading blanks (249, 0) (249, 1) TRUE (249, 2) FALSE (250, 0) (250, 1) TRUE (250, 2) (251, 0) (251, 1) TRUE (251, 2) Enter normally or Array Enter (252, 0) (252, 1) TRUE (252, 2) (253, 0) (253, 1) TRUE (253, 2) (254, 0) (254, 1) TRUE (254, 2) (255, 0) (255, 1) TRUE (255, 2) (256, 0) (256, 1) TRUE (256, 2) Sheet: Sheet: